CustomerRevolvingChargeAccount

Entity Definition

Logical Name : CustomerRevolvingChargeAccount
Physical Name : LE_ACNT_CT_CNS_CHG

A type of CUSTOMER ACCOUNT that allows a customer to make purchases on credit. This type of account is a "house" charge account and usually requires the customer to use a retailer charge card to settle a transaction.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerAccountID (FK)(PK) A unique identifier for a customer account. ID_CTAC Identity integer
CreditLimitAmount The maximum balance (principal) that may be carried by a customer in this charge account. MO_CR_LM_AMT Money decimal(16,5)
AnnualInterestRatePercent The annual rate used to calculate interest on the outstanding balance in this charge account. Most credit cards specify a daily percentage rate which is the annual rate divided by 365 (or a value close to that). PE_ANN_INTRST_RT Percent decimal(7,4)
PenaltyAnnualInterestRatePercent The annual interest percent charged for balances carred beyond the payment due date. PE_PNTY_ANN_INTRST_RT Percent decimal(7,4)
PenaltyFeeAmount A flat fee assessed for late or missed payments. MO_PNTY_FE_AMT Money decimal(16,5)
GracePeriodDayCount A number of days a creditor may choose to defer penalties and penalty interest rate. The grace period extends the payment due date and enables a customer to avoid incurring penalty fees and interest. DI_GRC_PRD_DY_CNT QuantityDayCount decimal(3,0)
BillingCycleMonthDay The month and day of the month that a payment must be made against the principal and interest balance in the account. DC_BLLNG_CYCL_MNTH_DY DateFiscalDay char(1)
MinimumInterestChargeAmount A mininmum monteary amount charged for interest. For example accrued interest of $.59 would result in a charge of $1.00. In this scenario the $1.00 is th eMinimumInterestChargedAmount MO_MNM_INTRST_CHG_AMT Money decimal(16,5)
MinimumPaymentAmount The minimum payment amount that must be paid on or before the billing cycle ending date in order to avoid penalty and interest. MO_MNM_PYM_AMT Money decimal(16,5)

Relationships

Parent Entity Verb Phrase Child Entity
CustomerAccount can be a CustomerRevolvingChargeAccount

Logical Views containing CustomerRevolvingChargeAccount

Logical View
Logical 07010 - Customer Account Information Extended
Logical 07200 - Customer Purchase Transaction History View